﻿Public Class clsProdSpec
    Public Function selectAllbySpecId(_prod_spec_id As String) As DataTable
        Dim szSql As String = ""
        szSql &= "SELECT prod_spec_id || '  (' || prod_spec_name  || ')' as mst_name ,* FROM sf.t_prod_spec "
        szSql &= " WHERE factory_id = ? and  prod_spec_id = ?"
        Return DBacs.ExecuteSql(szSql, -1, "TS", _prod_spec_id)
    End Function
End Class
